package com.example.drug.mapper;

import com.example.common.entity.Module;
import com.example.drug.dto.resp.PharmacistInfo;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public interface PharmacistMapper {

    @Select(value = "select a.head_nvarchar as Head,a.name_nvarchar as Name,a.title_nvarchar as Title,b.name_nvarchar as DepartmentName,a.is_online_bit as IsOnline"+
    ",a.certificate_code_nvarchar as CertificateCode,a.intro_nvarchar as Intro"+
    " from doctor_pharmacist a"+
    " inner join h_hospital_department b on a.depart_id_bigint = b.id_bigint"+
    " where a.dc_id_bigint = #{dcid}")
    PharmacistInfo findInfoByDCID(@Param("dcid") Long dcid);
}
